SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND p.iPostType=12 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=101 AND MATCH (t.strSearch) AGAINST ('+store +sales +ads' IN BOOLEAN MODE)) AND iCityID IN (68785,67046,70129,67826,69659,69689,68150,67314,67032,67084,68396,68668,69515,68405,69402,67967,68704,67054,67182,69412,68974,68794,67053,68844,69133,70139,70223,68068,67488,69527,67024,69518,67531,67399,70236,69220,69286) ORDER BY FIELD(iCityID, 68785,67046,70129,67826,69659,69689,68150,67314,67032,67084,68396,68668,69515,68405,69402,67967,68704,67054,67182,69412,68974,68794,67053,68844,69133,70139,70223,68068,67488,69527,67024,69518,67531,67399,70236,69220,69286) ASC, p.tmPosted DESC LIMIT 24
store sales ads, Community Classifieds, Local Events, Friends, Activities in Karamsad
